Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	166795
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	22.9 MiB
Average record size in memory	144.0 B

Variable types

Numeric	16
Categorical	2

Alerts

`City` is highly overall correlated with `County`	High correlation
`Clean Alternative Fuel Vehicle Eligibility` is highly overall correlated with `Electric Range` and 1 other fields	High correlation
`County` is highly overall correlated with `City` and 1 other fields	High correlation
`Electric Range` is highly overall correlated with `Clean Alternative Fuel Vehicle Eligibility` and 2 other fields	High correlation
`Electric Vehicle Type` is highly overall correlated with `Clean Alternative Fuel Vehicle Eligibility` and 1 other fields	High correlation
`Model` is highly overall correlated with `VIN (1-10)`	High correlation
`Model Year` is highly overall correlated with `Electric Range`	High correlation
`Postal Code` is highly overall correlated with `County`	High correlation
`VIN (1-10)` is highly overall correlated with `Model`	High correlation
`State` is highly skewed (γ1 = -27.56089108)	Skewed
`Postal Code` is highly skewed (γ1 = -30.09608692)	Skewed
`2020 Census Tract` is highly skewed (γ1 = -26.96677648)	Skewed
`DOL Vehicle ID` has unique values	Unique
`Electric Range` has 83517 (50.1%) zeros	Zeros
`Base MSRP` has 163433 (98.0%) zeros	Zeros

Reproduction

Analysis started	2024-03-11 03:39:52.080121
Analysis finished	2024-03-11 03:41:24.155860
Duration	1 minute and 32.08 seconds
Software version	ydata-profiling vv4.6.5
Download configuration	config.json

VIN (1-10)
Real number (ℝ)

HIGH CORRELATION

Distinct	259
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	169.79518

Minimum	1
Maximum	1114
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	17
median	52
Q3	196
95-th percentile	1029
Maximum	1114
Range	1113
Interquartile range (IQR)	179

Descriptive statistics

Standard deviation	269.25387
Coefficient of variation (CV)	1.5857568
Kurtosis	5.0768332
Mean	169.79518
Median Absolute Deviation (MAD)	43
Skewness	2.4018884
Sum	28320987
Variance	72497.646
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	2904	1.7%
4	2748	1.6%
3	2730	1.6%
5	2690	1.6%
2	2620	1.6%
11	2519	1.5%
10	2500	1.5%
7	2499	1.5%
8	2496	1.5%
12	2484	1.5%
Other values (249)	140605	84.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1968	1.2%
2	2620	1.6%
3	2730	1.6%
4	2748	1.6%
5	2690	1.6%
6	2904	1.7%
7	2499	1.5%
8	2496	1.5%
9	2439	1.5%
10	2500	1.5%

Value	Count	Frequency (%)
1114	1114	0.7%
1090	1090	0.7%
1071	2142	1.3%
1052	1052	0.6%
1041	1041	0.6%
1037	1037	0.6%
1029	1029	0.6%
1022	1022	0.6%
1014	1014	0.6%
993	993	0.6%

County
Real number (ℝ)

HIGH CORRELATION

Distinct	49
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49568.435

Minimum	1
Maximum	86594
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	943
Q1	9847
median	86594
Q3	86594
95-th percentile	86594
Maximum	86594
Range	86593
Interquartile range (IQR)	76747

Descriptive statistics

Standard deviation	38769.326
Coefficient of variation (CV)	0.78213738
Kurtosis	-1.9294575
Mean	49568.435
Median Absolute Deviation (MAD)	0
Skewness	-0.12137205
Sum	8.2677672 × 10⁹
Variance	1.5030607 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
86594	86594	51.9%
19570	19570	11.7%
12972	12972	7.8%
9847	9847	5.9%
6042	6042	3.6%
5522	5522	3.3%
4312	4312	2.6%
4039	4039	2.4%
2028	2028	1.2%
1842	1842	1.1%
Other values (39)	14027	8.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	86	0.1%
2	54	< 0.1%
3	27	< 0.1%
4	40	< 0.1%
5	20	< 0.1%
6	24	< 0.1%
7	14	< 0.1%
8	16	< 0.1%
9	18	< 0.1%
10	10	< 0.1%

Value	Count	Frequency (%)
86594	86594	51.9%
19570	19570	11.7%
12972	12972	7.8%
9847	9847	5.9%
6042	6042	3.6%
5522	5522	3.3%
4312	4312	2.6%
4039	4039	2.4%
2028	2028	1.2%
1842	1842	1.1%

City
Real number (ℝ)

HIGH CORRELATION

Distinct	208
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6920.752

Minimum	1
Maximum	27831
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	140
Q1	859
median	2597
Q3	6032
95-th percentile	27831
Maximum	27831
Range	27830
Interquartile range (IQR)	5173

Descriptive statistics

Standard deviation	9606.3751
Coefficient of variation (CV)	1.3880537
Kurtosis	0.82456682
Mean	6920.752
Median Absolute Deviation (MAD)	2239
Skewness	1.5953469
Sum	1.1543468 × 10⁹
Variance	92282443
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27831	27831	16.7%
8364	8364	5.0%
6032	6032	3.6%
5869	5869	3.5%
5440	5440	3.3%
5028	5028	3.0%
4876	4876	2.9%
4617	4617	2.8%
4058	4058	2.4%
3510	3510	2.1%
Other values (198)	91170	54.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	227	0.1%
2	150	0.1%
3	90	0.1%
4	88	0.1%
5	80	< 0.1%
6	60	< 0.1%
7	105	0.1%
8	80	< 0.1%
9	54	< 0.1%
10	60	< 0.1%

Value	Count	Frequency (%)
27831	27831	16.7%
8364	8364	5.0%
6032	6032	3.6%
5869	5869	3.5%
5440	5440	3.3%
5028	5028	3.0%
4876	4876	2.9%
4617	4617	2.8%
4058	4058	2.4%
3510	3510	2.1%

State
Real number (ℝ)

SKEWED

Distinct	41
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.954735

Minimum	0
Maximum	40
Zeros	5
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	39
Q1	39
median	39
Q3	39
95-th percentile	39
Maximum	40
Range	40
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.151665
Coefficient of variation (CV)	0.029564184
Kurtosis	786.2203
Mean	38.954735
Median Absolute Deviation (MAD)	0
Skewness	-27.560891
Sum	6497455
Variance	1.3263322
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
39	166440	99.8%
4	91	0.1%
38	38	< 0.1%
19	32	< 0.1%
36	24	< 0.1%
29	14	< 0.1%
13	13	< 0.1%
5	12	< 0.1%
9	10	< 0.1%
11	9	< 0.1%
Other values (31)	112	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	< 0.1%
1	1	< 0.1%
2	7	< 0.1%
3	2	< 0.1%
4	91	0.1%
5	12	< 0.1%
6	7	< 0.1%
7	4	< 0.1%
8	1	< 0.1%
9	10	< 0.1%

Value	Count	Frequency (%)
40	1	< 0.1%
39	166440	99.8%
38	38	< 0.1%
37	3	< 0.1%
36	24	< 0.1%
35	7	< 0.1%
34	1	< 0.1%
33	4	< 0.1%
32	6	< 0.1%
31	1	< 0.1%

Postal Code
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	836
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98173.714

Minimum	1730
Maximum	99577
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1730
5-th percentile	98006
Q1	98052
median	98122
Q3	98371
95-th percentile	98942
Maximum	99577
Range	97847
Interquartile range (IQR)	319

Descriptive statistics

Standard deviation	2442.5844
Coefficient of variation (CV)	0.024880228
Kurtosis	954.3603
Mean	98173.714
Median Absolute Deviation (MAD)	101
Skewness	-30.096087
Sum	1.6374885 × 10¹⁰
Variance	5966218.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98052	4252	2.5%
98012	3115	1.9%
98033	2840	1.7%
98006	2663	1.6%
98004	2652	1.6%
98115	2553	1.5%
98074	2341	1.4%
98072	2312	1.4%
98188	2286	1.4%
98034	2237	1.3%
Other values (826)	139544	83.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1730	1	< 0.1%
1731	1	< 0.1%
1824	1	< 0.1%
1908	1	< 0.1%
2842	1	< 0.1%
3804	1	< 0.1%
6355	1	< 0.1%
6371	1	< 0.1%
6379	2	< 0.1%
6385	1	< 0.1%

Value	Count	Frequency (%)
99577	1	< 0.1%
99403	57	< 0.1%
99402	9	< 0.1%
99371	1	< 0.1%
99362	329	0.2%
99361	12	< 0.1%
99360	7	< 0.1%
99357	19	< 0.1%
99356	1	< 0.1%
99354	283	0.2%

Model Year
Real number (ℝ)

HIGH CORRELATION

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2020.342

Minimum	1997
Maximum	2024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1997
5-th percentile	2014
Q1	2018
median	2021
Q3	2023
95-th percentile	2023
Maximum	2024
Range	27
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.0012851
Coefficient of variation (CV)	0.0014855332
Kurtosis	0.45023181
Mean	2020.342
Median Absolute Deviation (MAD)	2
Skewness	-1.0860991
Sum	3.3698294 × 10⁸
Variance	9.0077124
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
2023	51351	30.8%
2022	27592	16.5%
2021	18774	11.3%
2018	14150	8.5%
2020	11425	6.8%
2019	10859	6.5%
2017	8522	5.1%
2016	5518	3.3%
2015	4833	2.9%
2013	4454	2.7%
Other values (12)	9317	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1997	1	< 0.1%
1998	1	< 0.1%
1999	3	< 0.1%
2000	7	< 0.1%
2002	2	< 0.1%
2003	1	< 0.1%
2008	19	< 0.1%
2010	23	< 0.1%
2011	782	0.5%
2012	1630	1.0%

Value	Count	Frequency (%)
2024	3309	2.0%
2023	51351	30.8%
2022	27592	16.5%
2021	18774	11.3%
2020	11425	6.8%
2019	10859	6.5%
2018	14150	8.5%
2017	8522	5.1%
2016	5518	3.3%
2015	4833	2.9%

Make
Real number (ℝ)

Distinct	39
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.009353

Minimum	0
Maximum	38
Zeros	29
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	17
median	33
Q3	33
95-th percentile	36
Maximum	38
Range	38
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	11.153195
Coefficient of variation (CV)	0.44596097
Kurtosis	-0.82446467
Mean	25.009353
Median Absolute Deviation (MAD)	3
Skewness	-0.87790223
Sum	4171435
Variance	124.39376
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
33	74830	44.9%
27	13847	8.3%
6	13072	7.8%
11	8577	5.1%
4	7196	4.3%
18	6995	4.2%
35	5812	3.5%
36	4717	2.8%
17	4100	2.5%
15	4057	2.4%
Other values (29)	23592	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	29	< 0.1%
1	3464	2.1%
2	8	< 0.1%
3	3	< 0.1%
4	7196	4.3%
5	245	0.1%
6	13072	7.8%
7	2878	1.7%
8	28	< 0.1%
9	801	0.5%

Value	Count	Frequency (%)
38	3	< 0.1%
37	3962	2.4%
36	4717	2.8%
35	5812	3.5%
34	5	< 0.1%
33	74830	44.9%
32	788	0.5%
31	275	0.2%
30	3554	2.1%
29	1097	0.7%

Model
Real number (ℝ)

HIGH CORRELATION

Distinct	120
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14114.946

Minimum	1
Maximum	32822
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	360
Q1	1919
median	6413
Q3	28925
95-th percentile	32822
Maximum	32822
Range	32821
Interquartile range (IQR)	27006

Descriptive statistics

Standard deviation	13390.85
Coefficient of variation (CV)	0.94870007
Kurtosis	-1.656049
Mean	14114.946
Median Absolute Deviation (MAD)	6053
Skewness	0.40754717
Sum	2.3543024 × 10⁹
Variance	1.7931486 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32822	32822	19.7%
28925	28925	17.3%
13273	13273	8.0%
7610	7610	4.6%
6413	6413	3.8%
5428	5428	3.3%
4825	4825	2.9%
3647	3647	2.2%
3161	3161	1.9%
3107	3107	1.9%
Other values (110)	57584	34.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	< 0.1%
2	10	< 0.1%
3	6	< 0.1%
5	10	< 0.1%
6	6	< 0.1%
8	8	< 0.1%
10	30	< 0.1%
11	22	< 0.1%
12	12	< 0.1%
13	26	< 0.1%

Value	Count	Frequency (%)
32822	32822	19.7%
28925	28925	17.3%
13273	13273	8.0%
7610	7610	4.6%
6413	6413	3.8%
5428	5428	3.3%
4825	4825	2.9%
3647	3647	2.2%
3161	3161	1.9%
3107	3107	1.9%

Electric Vehicle Type
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	130288
1	36507

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	166795
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	130288	78.1%
1	36507	21.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	130288	78.1%
1	36507	21.9%

Most occurring characters

Value	Count	Frequency (%)
0	130288	78.1%
1	36507	21.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	166795	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	130288	78.1%
1	36507	21.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	166795	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	130288	78.1%
1	36507	21.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	166795	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	130288	78.1%
1	36507	21.9%

Clean Alternative Fuel Vehicle Eligibility
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	83517
0	64294
2	18984

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	166795
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	2
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	83517	50.1%
0	64294	38.5%
2	18984	11.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	83517	50.1%
0	64294	38.5%
2	18984	11.4%

Most occurring characters

Value	Count	Frequency (%)
1	83517	50.1%
0	64294	38.5%
2	18984	11.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	166795	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	83517	50.1%
0	64294	38.5%
2	18984	11.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	166795	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	83517	50.1%
0	64294	38.5%
2	18984	11.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	166795	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	83517	50.1%
0	64294	38.5%
2	18984	11.4%

Electric Range
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	102
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.505057

Minimum	0
Maximum	337
Zeros	83517
Zeros (%)	50.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	84
95-th percentile	259
Maximum	337
Range	337
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	93.269778
Coefficient of variation (CV)	1.5164571
Kurtosis	0.38748856
Mean	61.505057
Median Absolute Deviation (MAD)	0
Skewness	1.3744808
Sum	10258736
Variance	8699.2515
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	83517	50.1%
215	6272	3.8%
220	4101	2.5%
84	3918	2.3%
25	3918	2.3%
238	3790	2.3%
21	3298	2.0%
32	3182	1.9%
208	2472	1.5%
53	2466	1.5%
Other values (92)	49861	29.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	83517	50.1%
6	935	0.6%
8	35	< 0.1%
9	21	< 0.1%
10	162	0.1%
11	3	< 0.1%
12	164	0.1%
13	358	0.2%
14	1109	0.7%
15	89	0.1%

Value	Count	Frequency (%)
337	74	< 0.1%
330	318	0.2%
322	1671	1.0%
308	485	0.3%
293	443	0.3%
291	2335	1.4%
289	646	0.4%
270	275	0.2%
266	1400	0.8%
265	124	0.1%

Base MSRP
Real number (ℝ)

ZEROS

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1152.1645

Minimum	0
Maximum	845000
Zeros	163433
Zeros (%)	98.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	845000
Range	845000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8657.8981
Coefficient of variation (CV)	7.5144637
Kurtosis	603.44483
Mean	1152.1645
Median Absolute Deviation (MAD)	0
Skewness	12.852734
Sum	1.9217528 × 10⁸
Variance	74959200
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
0	163433	98.0%
69900	1390	0.8%
31950	381	0.2%
52900	220	0.1%
32250	141	0.1%
54950	130	0.1%
59900	124	0.1%
39995	111	0.1%
36900	100	0.1%
44100	95	0.1%
Other values (21)	670	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	163433	98.0%
31950	381	0.2%
32250	141	0.1%
32995	3	< 0.1%
33950	72	< 0.1%
34995	67	< 0.1%
36800	54	< 0.1%
36900	100	0.1%
39995	111	0.1%
43700	11	< 0.1%

Value	Count	Frequency (%)
845000	1	< 0.1%
184400	10	< 0.1%
110950	20	< 0.1%
109000	6	< 0.1%
102000	15	< 0.1%
98950	19	< 0.1%
91250	5	< 0.1%
90700	20	< 0.1%
89100	7	< 0.1%
81100	22	< 0.1%

Legislative District
Real number (ℝ)

Distinct	49
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.187074

Minimum	1
Maximum	49
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	18
median	33
Q3	42
95-th percentile	48
Maximum	49
Range	48
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	14.838763
Coefficient of variation (CV)	0.50840187
Kurtosis	-1.0831421
Mean	29.187074
Median Absolute Deviation (MAD)	11
Skewness	-0.46729894
Sum	4868258
Variance	220.18889
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
41	10837	6.5%
45	10062	6.0%
48	9158	5.5%
1	7231	4.3%
5	7062	4.2%
36	6977	4.2%
11	6607	4.0%
46	6464	3.9%
43	6172	3.7%
37	4933	3.0%
Other values (39)	91292	54.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7231	4.3%
2	1885	1.1%
3	824	0.5%
4	1385	0.8%
5	7062	4.2%
6	1593	1.0%
7	787	0.5%
8	1726	1.0%
9	930	0.6%
10	2879	1.7%

Value	Count	Frequency (%)
49	2250	1.3%
48	9158	5.5%
47	3032	1.8%
46	6464	3.9%
45	10062	6.0%
44	4337	2.6%
43	6172	3.7%
42	2315	1.4%
41	10837	6.5%
40	3637	2.2%

DOL Vehicle ID
Real number (ℝ)

UNIQUE

Distinct	166795
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1724184 × 10⁸

Minimum	4385
Maximum	4.7925477 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	4385
5-th percentile	1.0927167 × 10⁸
Q1	1.7907484 × 10⁸
median	2.2440553 × 10⁸
Q3	2.5134214 × 10⁸
95-th percentile	3.4420524 × 10⁸
Maximum	4.7925477 × 10⁸
Range	4.7925039 × 10⁸
Interquartile range (IQR)	72267307

Descriptive statistics

Standard deviation	77272387
Coefficient of variation (CV)	0.35569753
Kurtosis	3.4970115
Mean	2.1724184 × 10⁸
Median Absolute Deviation (MAD)	30843393
Skewness	0.7258894
Sum	3.6234853 × 10¹³
Variance	5.9710219 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1593721	1	< 0.1%
196311664	1	< 0.1%
181452680	1	< 0.1%
142435835	1	< 0.1%
148905543	1	< 0.1%
249787583	1	< 0.1%
220480571	1	< 0.1%
249691865	1	< 0.1%
131525467	1	< 0.1%
233740279	1	< 0.1%
Other values (166785)	166785	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4385	1	< 0.1%
4777	1	< 0.1%
10286	1	< 0.1%
10734	1	< 0.1%
12050	1	< 0.1%
23145	1	< 0.1%
24629	1	< 0.1%
27702	1	< 0.1%
35325	1	< 0.1%
46112	1	< 0.1%

Value	Count	Frequency (%)
479254772	1	< 0.1%
479114996	1	< 0.1%
478935460	1	< 0.1%
478934571	1	< 0.1%
478926346	1	< 0.1%
478925947	1	< 0.1%
478925163	1	< 0.1%
478924358	1	< 0.1%
478916028	1	< 0.1%
478910428	1	< 0.1%

Electric Utility
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70131.494

Minimum	3
Maximum	98811
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	3
5-th percentile	29601
Q1	32454
median	98811
Q3	98811
95-th percentile	98811
Maximum	98811
Range	98808
Interquartile range (IQR)	66357

Descriptive statistics

Standard deviation	35015.822
Coefficient of variation (CV)	0.49928813
Kurtosis	-1.606193
Mean	70131.494
Median Absolute Deviation (MAD)	0
Skewness	-0.46860742
Sum	1.1697583 × 10¹⁰
Variance	1.2261078 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
98811	98811	59.2%
32454	32454	19.5%
29601	29601	17.7%
1245	1245	0.7%
1059	1059	0.6%
989	989	0.6%
530	530	0.3%
372	372	0.2%
355	355	0.2%
335	335	0.2%
Other values (11)	1044	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	3	< 0.1%
5	5	< 0.1%
6	6	< 0.1%
40	40	< 0.1%
42	42	< 0.1%
56	56	< 0.1%
98	98	0.1%
139	139	0.1%
186	186	0.1%
222	222	0.1%

Value	Count	Frequency (%)
98811	98811	59.2%
32454	32454	19.5%
29601	29601	17.7%
1245	1245	0.7%
1059	1059	0.6%
989	989	0.6%
530	530	0.3%
372	372	0.2%
355	355	0.2%
335	335	0.2%

2020 Census Tract
Real number (ℝ)

SKEWED

Distinct	2088
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.2977092 × 10¹⁰

Minimum	1.0010201 × 10⁹
Maximum	5.6033 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1.0010201 × 10⁹
5-th percentile	5.3011041 × 10¹⁰
Q1	5.303301 × 10¹⁰
median	5.303303 × 10¹⁰
Q3	5.3053073 × 10¹⁰
95-th percentile	5.3067012 × 10¹⁰
Maximum	5.6033 × 10¹⁰
Range	5.503198 × 10¹⁰
Interquartile range (IQR)	20063300

Descriptive statistics

Standard deviation	1.5697544 × 10⁹
Coefficient of variation (CV)	0.029630815
Kurtosis	751.92796
Mean	5.2977092 × 10¹⁰
Median Absolute Deviation (MAD)	27702
Skewness	-26.966776
Sum	8.836314 × 10¹⁵
Variance	2.4641288 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.30330282 × 10¹⁰	1914	1.1%
5.30330285 × 10¹⁰	1001	0.6%
5.303303232 × 10¹⁰	763	0.5%
5.30330262 × 10¹⁰	713	0.4%
5.30330093 × 10¹⁰	647	0.4%
5.30670112 × 10¹⁰	624	0.4%
5.303303232 × 10¹⁰	564	0.3%
5.303303222 × 10¹⁰	545	0.3%
5.303302501 × 10¹⁰	532	0.3%
5.306105211 × 10¹⁰	529	0.3%
Other values (2078)	158963	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1001020100	2	< 0.1%
1081041901	1	< 0.1%
1097006803	1	< 0.1%
1117030352	1	< 0.1%
2020000206	1	< 0.1%
4013115900	1	< 0.1%
4013216901	1	< 0.1%
4013610301	1	< 0.1%
4013610302	1	< 0.1%
4013610500	1	< 0.1%

Value	Count	Frequency (%)
5.60330001 × 10¹⁰	1	< 0.1%
5.307794001 × 10¹⁰	5	< 0.1%
5.307794001 × 10¹⁰	3	< 0.1%
5.307794 × 10¹⁰	2	< 0.1%
5.307794 × 10¹⁰	7	< 0.1%
5.307794 × 10¹⁰	7	< 0.1%
5.307794 × 10¹⁰	3	< 0.1%
5.30770034 × 10¹⁰	33	< 0.1%
5.30770032 × 10¹⁰	40	< 0.1%
5.30770031 × 10¹⁰	20	< 0.1%

Longitude
Real number (ℝ)

Distinct	834
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.03183

Minimum	-159.71248
Maximum	-70.873801
Zeros	0
Zeros (%)	0.0%
Negative	166795
Negative (%)	100.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	-159.71248
5-th percentile	-122.87571
Q1	-122.39418
median	-122.29179
Q3	-122.15166
95-th percentile	-119.29521
Maximum	-70.873801
Range	88.838679
Interquartile range (IQR)	0.24252

Descriptive statistics

Standard deviation	1.8138196
Coefficient of variation (CV)	-0.014863496
Kurtosis	376.00813
Mean	-122.03183
Median Absolute Deviation (MAD)	0.13445
Skewness	15.555343
Sum	-20354299
Variance	3.2899414
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.12302	4257	2.6%
-122.1873	3115	1.9%
-122.20264	2840	1.7%
-122.16937	2663	1.6%
-122.201905	2652	1.6%
-122.3185	2553	1.5%
-122.0313266	2341	1.4%
-122.151665	2312	1.4%
-122.29179	2286	1.4%
-122.209285	2237	1.3%
Other values (824)	139539	83.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-159.71248	1	< 0.1%
-158.019325	1	< 0.1%
-158.009805	1	< 0.1%
-157.9124	3	< 0.1%
-157.74382	1	< 0.1%
-156.4531185	1	< 0.1%
-155.97182	1	< 0.1%
-149.5683	1	< 0.1%
-124.62514	8	< 0.1%
-124.3727994	3	< 0.1%

Value	Count	Frequency (%)
-70.873801	1	< 0.1%
-70.930195	1	< 0.1%
-71.2733214	1	< 0.1%
-71.2785	1	< 0.1%
-71.30025	1	< 0.1%
-71.3487326	1	< 0.1%
-71.8380592	2	< 0.1%
-71.967835	1	< 0.1%
-72.1392432	1	< 0.1%
-72.27884	1	< 0.1%

Latitude
Real number (ℝ)

Distinct	835
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.441833

Minimum	19.61021
Maximum	61.323155
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	19.61021
5-th percentile	45.703706
Q1	47.357985
median	47.610365
Q3	47.71558
95-th percentile	48.21928
Maximum	61.323155
Range	41.712945
Interquartile range (IQR)	0.357595

Descriptive statistics

Standard deviation	0.82667522
Coefficient of variation (CV)	0.017425027
Kurtosis	165.34532
Mean	47.441833
Median Absolute Deviation (MAD)	0.162425
Skewness	-8.5829475
Sum	7913060.5
Variance	0.68339192
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.67668	4257	2.6%
47.820245	3115	1.9%
47.6785	2840	1.7%
47.571015	2663	1.6%
47.61385	2652	1.6%
47.67949	2553	1.5%
47.6285782	2341	1.4%
47.75855	2312	1.4%
47.43473	2286	1.4%
47.71124	2237	1.3%
Other values (825)	139539	83.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.61021	1	< 0.1%
20.7761437	1	< 0.1%
21.33516	1	< 0.1%
21.343675	3	< 0.1%
21.39805	1	< 0.1%
21.455635	1	< 0.1%
21.969958	1	< 0.1%
25.765985	1	< 0.1%
26.257025	1	< 0.1%
26.6734075	1	< 0.1%

Value	Count	Frequency (%)
61.323155	1	< 0.1%
48.99634	12	< 0.1%
48.99505	380	0.2%
48.9895316	1	< 0.1%
48.98823	53	< 0.1%
48.9492931	28	< 0.1%
48.9461196	217	0.1%
48.935165	16	< 0.1%
48.927085	8	< 0.1%
48.919121	25	< 0.1%

Auto

Heatmap
Table

	2020 Census Tract	Base MSRP	City	Clean Alternative Fuel Vehicle Eligibility	County	DOL Vehicle ID	Electric Range	Electric Utility	Electric Vehicle Type	Latitude	Legislative District	Longitude	Make	Model	Model Year	Postal Code	State	VIN (1-10)
2020 Census Tract	1.000	0.000	-0.365	0.009	-0.312	0.011	-0.015	0.457	0.013	0.215	-0.186	0.128	-0.016	0.016	0.011	0.058	0.080	0.009
Base MSRP	0.000	1.000	-0.005	0.024	-0.002	-0.035	0.116	-0.000	0.022	0.006	0.011	-0.002	0.003	-0.109	-0.190	-0.003	-0.005	-0.158
City	-0.365	-0.005	1.000	0.044	0.608	-0.000	-0.020	-0.208	0.065	0.107	0.394	-0.004	0.051	0.041	0.028	-0.386	0.079	0.045
Clean Alternative Fuel Vehicle Eligibility	0.009	0.024	0.044	1.000	0.012	0.092	-0.717	0.022	0.743	-0.027	-0.018	0.017	0.067	-0.082	0.455	-0.005	-0.001	-0.001
County	-0.312	-0.002	0.608	0.012	1.000	0.013	-0.052	0.112	0.099	0.118	0.434	0.308	0.066	0.075	0.074	-0.746	0.085	0.084
DOL Vehicle ID	0.011	-0.035	-0.000	0.092	0.013	1.000	-0.160	0.026	0.078	-0.018	-0.017	0.017	-0.008	-0.060	0.348	-0.006	0.012	0.069
Electric Range	-0.015	0.116	-0.020	-0.717	-0.052	-0.160	1.000	-0.049	0.525	0.005	-0.004	-0.047	-0.113	-0.127	-0.697	0.055	-0.007	-0.195
Electric Utility	0.457	-0.000	-0.208	0.022	0.112	0.026	-0.049	1.000	0.082	0.154	0.059	0.218	0.031	0.070	0.067	-0.437	0.088	0.070
Electric Vehicle Type	0.013	0.022	0.065	0.743	0.099	0.078	0.525	0.082	1.000	-0.054	-0.068	-0.056	-0.296	-0.489	-0.159	0.109	-0.014	-0.445
Latitude	0.215	0.006	0.107	-0.027	0.118	-0.018	0.005	0.154	-0.054	1.000	0.238	0.143	0.031	0.036	-0.019	-0.324	0.079	0.031
Legislative District	-0.186	0.011	0.394	-0.018	0.434	-0.017	-0.004	0.059	-0.068	0.238	1.000	0.021	0.048	0.036	-0.014	-0.337	-0.000	0.031
Longitude	0.128	-0.002	-0.004	0.017	0.308	0.017	-0.047	0.218	-0.056	0.143	0.021	1.000	0.062	0.099	0.065	-0.353	-0.068	0.090
Make	-0.016	0.003	0.051	0.067	0.066	-0.008	-0.113	0.031	-0.296	0.031	0.048	0.062	1.000	0.494	0.092	-0.091	-0.006	0.424
Model	0.016	-0.109	0.041	-0.082	0.075	-0.060	-0.127	0.070	-0.489	0.036	0.036	0.099	0.494	1.000	0.064	-0.109	0.002	0.822
Model Year	0.011	-0.190	0.028	0.455	0.074	0.348	-0.697	0.067	-0.159	-0.019	-0.014	0.065	0.092	0.064	1.000	-0.061	0.015	0.180
Postal Code	0.058	-0.003	-0.386	-0.005	-0.746	-0.006	0.055	-0.437	0.109	-0.324	-0.337	-0.353	-0.091	-0.109	-0.061	1.000	0.079	-0.105
State	0.080	-0.005	0.079	-0.001	0.085	0.012	-0.007	0.088	-0.014	0.079	-0.000	-0.068	-0.006	0.002	0.015	0.079	1.000	0.007
VIN (1-10)	0.009	-0.158	0.045	-0.001	0.084	0.069	-0.195	0.070	-0.445	0.031	0.031	0.090	0.424	0.822	0.180	-0.105	0.007	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	VIN (1-10)	County	City	State	Postal Code	Model Year	Make	Model	Electric Vehicle Type	Clean Alternative Fuel Vehicle Eligibility	Electric Range	Legislative District	DOL Vehicle ID	Electric Utility	2020 Census Tract	Longitude	Latitude
0	8	943	639	39	98902.0	2014	9	801	0	0	87	14.0	1593721	1245	5.307700e+10	-120.524012	46.597394
1	4	6042	4058	39	98513.0	2017	33	5428	0	0	200	2.0	257167501	98811	5.306701e+10	-122.817545	46.988760
2	5	86594	4617	39	98058.0	2023	4	431	1	2	20	11.0	224071816	98811	5.303303e+10	-122.129888	47.445126
3	98	19570	5440	39	98012.0	2023	30	1622	0	1	0	21.0	260084653	98811	5.306105e+10	-122.187300	47.820245
4	170	86594	2602	39	98031.0	2020	33	28925	0	0	322	33.0	253771913	98811	5.303303e+10	-122.201252	47.393181
5	35	5522	655	39	98370.0	2024	4	2301	1	0	39	23.0	259427829	98811	5.303594e+10	-122.641770	47.737525
6	11	5522	988	39	98367.0	2018	7	2878	1	0	33	26.0	477087012	98811	5.303509e+10	-122.684707	47.505240
7	75	5522	655	39	98370.0	2017	6	6413	0	0	238	23.0	214494213	98811	5.303509e+10	-122.641770	47.737525
8	231	5522	988	39	98366.0	2018	33	28925	0	0	215	26.0	280785123	98811	5.303509e+10	-122.639265	47.537300
9	3	86594	581	39	98019.0	2018	4	1919	0	0	114	45.0	129133343	98811	5.303303e+10	-121.981075	47.737796

	VIN (1-10)	County	City	State	Postal Code	Model Year	Make	Model	Electric Vehicle Type	Clean Alternative Fuel Vehicle Eligibility	Electric Range	Legislative District	DOL Vehicle ID	Electric Utility	2020 Census Tract	Longitude	Latitude
166785	3	86594	27831	39	98102.0	2024	15	175	1	0	33	43.0	258782814	29601	5.303301e+10	-122.322260	47.640580
166786	18	4039	2782	39	98225.0	2024	17	3161	1	2	21	42.0	261031214	98811	5.307300e+10	-122.486115	48.761615
166787	148	1842	664	39	98221.0	2013	27	13273	0	0	75	10.0	259757998	98811	5.305794e+10	-122.615305	48.501275
166788	7	86594	5028	39	98033.0	2022	29	608	0	1	0	48.0	199014224	98811	5.303302e+10	-122.202640	47.678500
166789	75	597	21	39	98925.0	2022	18	2043	0	1	0	13.0	212130950	98811	5.303798e+10	-121.176163	47.241060
166790	13	4312	2573	39	99223.0	2013	11	1778	1	2	19	6.0	239527123	32454	5.306300e+10	-117.369705	47.626370
166791	410	86594	4876	39	98074.0	2021	33	32822	0	1	0	45.0	148715479	98811	5.303303e+10	-122.031327	47.628578
166792	375	19570	737	39	98275.0	2022	33	32822	0	1	0	21.0	220504406	98811	5.306104e+10	-122.299965	47.941710
166793	10	709	28	39	98564.0	2013	6	4825	1	0	38	20.0	156418475	32454	5.304197e+10	-122.487535	46.529013
166794	59	12972	1852	39	98332.0	2017	33	7610	0	0	210	26.0	169045789	32454	5.305307e+10	-122.589645	47.342345

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample